<?php
/* -------------------------------------------------------------------------------------
* 	ID:						$Id: zones.php 129 2013-09-21 12:12:11Z phone.mueller@googlemail.com $
* 	Letzter Stand:			$Revision: 129 $
* 	zuletzt geaendert von:	$Author: siekiera $
* 	Datum:					$Date: 2013-09-21 12:12:11 +0000 (Sat, 21 Sep 2013) $
*
* 	SEO:mercari by Siekiera Media
* 	http://www.seo-mercari.de
*
* 	Copyright (c) since 2011 SEO:mercari
* --------------------------------------------------------------------------------------
* 	based on:
* 	(c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
* 	(c) 2002-2003 osCommerce - www.oscommerce.com
* 	(c) 2003     nextcommerce - www.nextcommerce.org
* 	(c) 2005     xt:Commerce - www.xt-commerce.com
*
* 	Released under the GNU General Public License
* ----------------------------------------------------------------------------------- */

require('includes/application_top.php');

if ($_GET['action']) {
	switch ($_GET['action']) {
		case 'insert':
			$zone_country_id = $_POST['zone_country_id'];
			$zone_code = $_POST['zone_code'];
			$zone_name = $_POST['zone_name'];

			$db->db_query("INSERT INTO
								".TABLE_ZONES." (zone_country_id, zone_code, zone_name)
							VALUES
								(".$db->db_prepare($zone_country_id).", ".$db->db_prepare($zone_code).", ".$db->db_prepare($zone_name).")");
			redirect(href_link(FILENAME_ZONES));
		break;

		case 'save':
			$zone_id = $_GET['cID'];
			$zone_country_id = $_POST['zone_country_id'];
			$zone_code = $_POST['zone_code'];
			$zone_name = $_POST['zone_name'];

			$db->db_query("UPDATE
								".TABLE_ZONES."
							SET
								zone_country_id = ".$db->db_prepare($zone_country_id).",
								zone_code = ".$db->db_prepare($zone_code).",
								zone_name = ".$db->db_prepare($zone_name)."
							WHERE
								zone_id = ".$db->db_prepare($zone_id));
			redirect(href_link(FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$zone_id));
		break;

		case 'deleteconfirm':
			$zone_id = $_GET['cID'];

			$db->db_query("DELETE FROM ".TABLE_ZONES." WHERE zone_id = ".$db->db_prepare($zone_id));
			redirect(href_link(FILENAME_ZONES, 'page='.$_GET['page']));
		break;
	}
}
require(DIR_WS_INCLUDES.'metatag.php');
?>
</head>
<body>
<?php require(DIR_WS_INCLUDES.'header.php'); ?>
<div id="wrapper">
<table class="outerTable" cellpadding="0" cellspacing="0">
  <tr>
    <td class="columnLeft2" width="<?php echo BOX_WIDTH; ?>" valign="top">
		<?php require(DIR_WS_INCLUDES.'column_left.php'); ?>
	</td>
    <td class="boxCenter" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
      <tr>
        <td>
			<table class="table_pageHeading" border="0" width="100%" cellspacing="0" cellpadding="0">
          		<tr>
            		<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
          		</tr>
        	</table>
		</td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td valign="top"><table width="100%" cellspacing="0" cellpadding="0" class="dataTable">
              <tr class="dataTableHeadingRow">
                <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_COUNTRY_NAME; ?></td>
                <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ZONE_NAME; ?></td>
                <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_ZONE_CODE; ?></td>
                <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>
              </tr>
			<?php
			  $sql= "SELECT z.zone_id, c.countries_id, c.countries_name, z.zone_name, z.zone_code, z.zone_country_id from ".TABLE_ZONES." z, ".TABLE_COUNTRIES." c WHERE z.zone_country_id = c.countries_id ORDER BY c.countries_name, z.zone_name";
			  
			  $query = page_break_create($_POST['per_site'], $_GET['page'], $sql, 'zones.php');
			  
			  $zones = $query['query'];
			  while(!$zones->EOF) { $rows++;
			    if (((!$_GET['cID']) || (@$_GET['cID'] == $zones->fields['zone_id'])) && (!$cInfo) && (substr($_GET['action'], 0, 3) != 'new')) {
			      $cInfo = new objectInfo($zones->fields);
			    }

			    if ( (is_object($cInfo)) && ($zones->fields['zone_id'] == $cInfo->zone_id) ) {
			      echo '<tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'pointer\'" onclick="document.location.href=\''.href_link(FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$cInfo->zone_id.'&action=edit').'\'">'."\n";
			    } else {
					if ($rows % 2 == 0)
			    		$f = 'dataTableRow';
			    	else
			    		$f = '';
			      	echo '<tr class="'.$f.'" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'pointer\'" onmouseout="this.className=\''.$f.'\'" onclick="document.location.href=\''.href_link(FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$zones->fields['zone_id']).'\'">'."\n";
			    }
			?>
                <td class="dataTableContent"><?php echo $zones->fields['countries_name']; ?></td>
                <td class="dataTableContent"><?php echo $zones->fields['zone_name']; ?></td>
                <td class="dataTableContent" align="center"><?php echo $zones->fields['zone_code']; ?></td>
                <td class="dataTableContent" align="right"><?php if ( (is_object($cInfo)) && ($zones->fields['zone_id'] == $cInfo->zone_id) ) { echo image(DIR_WS_IMAGES.'icon_arrow_right.gif', ''); } else { echo '<a href="'.href_link(FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$zones->fields['zone_id']).'">'.image(DIR_WS_IMAGES.'icon_info.gif', IMAGE_ICON_INFO).'</a>'; } ?>&nbsp;</td>
			<?php
				echo '</tr>';
				$zones->MoveNext();
			  }
			?>
            </table>
		</td>
		<?php
		  $heading = array();
		  $contents = array();
		  switch ($_GET['action']) {
		    case 'new':
		      $heading[] = array('text' => '<b>'.TEXT_INFO_HEADING_NEW_ZONE.'</b>');

		      $contents = array('form' => draw_form('zones', FILENAME_ZONES, 'page='.$_GET['page'].'&action=insert'));
		      $contents[] = array('text' => TEXT_INFO_INSERT_INTRO);
		      $contents[] = array('text' => '<br />'.TEXT_INFO_ZONES_NAME.'<br />'.draw_input_field('zone_name'));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_ZONES_CODE.'<br />'.draw_input_field('zone_code'));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_NAME.'<br />'.draw_pull_down_menu('zone_country_id', get_countries()));
		      $contents[] = array('align' => 'center', 'text' => '<br /><button type="submit" class="button" onclick="this.blur();">'.BUTTON_INSERT.'</button>&nbsp;<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_ZONES, 'page='.$_GET['page']).'">'.BUTTON_CANCEL.'</a>');
		      break;
		    case 'edit':
		      $heading[] = array('text' => '<b>'.TEXT_INFO_HEADING_EDIT_ZONE.'</b>');

		      $contents = array('form' => draw_form('zones', FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$cInfo->zone_id.'&action=save'));
		      $contents[] = array('text' => TEXT_INFO_EDIT_INTRO);
		      $contents[] = array('text' => '<br />'.TEXT_INFO_ZONES_NAME.'<br />'.draw_input_field('zone_name', $cInfo->zone_name));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_ZONES_CODE.'<br />'.draw_input_field('zone_code', $cInfo->zone_code));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_NAME.'<br />'.draw_pull_down_menu('zone_country_id', get_countries(), $cInfo->countries_id));
		      $contents[] = array('align' => 'center', 'text' => '<br /><button type="submit" class="button" onclick="this.blur();">'. BUTTON_UPDATE.'</button>&nbsp;<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$cInfo->zone_id).'">'.BUTTON_CANCEL.'</a>');
		      break;
		    case 'delete':
		      $heading[] = array('text' => '<b>'.TEXT_INFO_HEADING_DELETE_ZONE.'</b>');

		      $contents = array('form' => draw_form('zones', FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$cInfo->zone_id.'&action=deleteconfirm'));
		      $contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
		      $contents[] = array('text' => '<br /><b>'.$cInfo->zone_name.'</b>');
		      $contents[] = array('align' => 'center', 'text' => '<br /><input type="submit" class="button" onClick="this.blur();" value="'.BUTTON_DELETE.'"/>&nbsp;<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$cInfo->zone_id).'">'.BUTTON_CANCEL.'</a>');
		      break;
		    default:
		      if (is_object($cInfo)) {
		        $heading[] = array('text' => '<b>'.$cInfo->zone_name.'</b>');

		        $contents[] = array('align' => 'center', 'text' => '<a class="button" onclick="this.blur();" href="'.href_link(FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$cInfo->zone_id.'&action=edit').'">'.BUTTON_EDIT.'</a> <a class="button" onclick="this.blur();" href="'.href_link(FILENAME_ZONES, 'page='.$_GET['page'].'&cID='.$cInfo->zone_id.'&action=delete').'">'.BUTTON_DELETE.'</a>');
		        $contents[] = array('text' => '<br />'.TEXT_INFO_ZONES_NAME.'<br />'.$cInfo->zone_name.' ('.$cInfo->zone_code.')');
		        $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_NAME.' '.$cInfo->countries_name);
		      }
		      break;
		  }

			 if ( (not_null($heading)) && (not_null($contents)) ) {
			   echo '            <td width="25%" class="border" valign="top">'."\n";

			   $box = new box;
			   echo $box->infoBox($heading, $contents);

			   echo '            </td>'."\n";
			 }
			$page_dropdown = '<form name="anzahl" action="'.$_SERVER['REQUEST_URI'].'" method="GET">'. "\n";

			if($_GET['page'] != '')
				$page_dropdown .= draw_hidden_field('page', $_GET['page'])."\n";

			$page_options = Array();

			$page_options[] = array('id' => '10', 'text' => '10');
			$page_options[] = array('id' => '20', 'text' => '20');
			$page_options[] = array('id' => '50', 'text' => '50');
			$page_options[] = array('id' => '100', 'text' => '100');
			$page_options[] = array('id' => '1000', 'text' => 'alle');

			$page_dropdown .= draw_pull_down_menu('anzahl', $page_options, ($_GET['anzahl'] != '' ? $_GET['anzahl'] : '20'), 'onchange="this.form.submit()"')."\n";

			$page_dropdown .= '</form>'."\n";
			?>
          </tr>
		  <tr>
		  	<td colspan="2">
			<table border="0" width="100%" cellspacing="0" cellpadding="2">
			<?php
			 if (!$_GET['action']) {
			?>
              <tr>
                <td colspan="2" align="right">
					<?php echo '<a class="button" onclick="this.blur();" href="'.href_link(FILENAME_ZONES, 'page='.$_GET['page'].'&action=new').'">'.BUTTON_NEW_ZONE.'</a>'; ?>
				</td>
              </tr>
			<?php
			  }
			?>
				<tr class="page_break">
					<td class="smallText" valign="top" width="33.3%"><?php echo 'Angezeigt werden '.$query['from'].' bis '.$query['to'].' (von insgesamt '.$query['total'].' Artikeln)'; ?></td>
					<td class="smallText" align="center" width="33.3%"></td>
					<td class="smallText" align="right" width="33.3%">
						Bundesländer pro Seite: <?php echo $query['page_break']->perSiteDropdown($_GET['page']); ?>
					</td>
				</tr>
				<tr><td align="center" colspan="3"><?php echo '<br />'.$query['links']; ?></td></tr>
            </table>
			</td>
		  </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
<?php require(DIR_WS_INCLUDES.'footer.php'); ?>
</body>
</html>
<?php require(DIR_WS_INCLUDES.'application_bottom.php'); ?>